
Combine first and last names
Ava + Reed → Ava Reed
Ready-made fixes for messy spreadsheet data. Pick the problem, download the file, paste in your list.
763 templates

Ava + Reed → Ava Reed

Skips an empty middle name → Ava Reed

Ava Reed → A. Reed

Ava + Reed → Reed, Ava

Ava + Reed → AR

Dr. + Ava Reed → Dr. Ava Reed

Ava Reed + Jr. → Ava Reed, Jr.

Ava + Marie + Reed → Ava M. Reed

Ava + Marie + Reed → Reed, Ava M.

Ava + Reed → Ava R.

Ava + Marie + Reed → AMR

Ava + Noah + Reed → Ava & Noah Reed

Ava Reed + Noah Park → Ava Reed & Noah Park

Reed → The Reed Family

Ava Reed + Avie → Ava Reed (Avie)

Ava + Avie + Reed → Avie Reed

Ava → Dear Ava,

Ava + Reed → Reed, A.

Reed + Park → Reed-Park

Ava + Avie + Reed → Ava (Avie) Reed

Dr. + Reed → Dear Dr. Reed,

Ava Reed + Acme → Ava Reed — Acme

Ava Reed + Treasurer → Ava Reed ¶ Treasurer

Ava Reed → Attn: Ava Reed

Ava Reed → c/o Ava Reed

Ava Reed + CPA + MBA → Ava Reed, CPA, MBA

Ava Reed + 27 → Ava Reed (0027)

DE LA + CRUZ → de la Cruz

Ava + Marie + Reed + Jr. → Ava M. Reed Jr.

Ava + Marie + Reed + Jr. → Reed Jr., Ava Marie

Ava Reed + Noah Reed → Ava & Noah Reed

Dr. + Reed + Prof. + Park → Dear Dr. Reed and Prof. Park,

Ava + Reed → reed|ava

Ava + Noah + Mia → Ava, Noah and Mia

Person + Ava Reed + Acme → Ava Reed

Ava + Reed → areed

Ava + Reed → ava.reed

Ava + Marie + Anne + Reed → Ava M. A. Reed

Ava + Marie + Reed → ARM

Ava + Ava Reed → Ava Reed

Ava Reed + Reed → Ava Reed

Ava Marie Reed + Ava Reed → Ava Marie Reed / Ava Reed

Ava + Reed → Ava R***

AVA + van Dijk → Ava van Dijk

AVA + Reed → Ava REED

Noah Park + Ava Reed → Ava Reed & Noah Park

Ava + Reed + Park → Ava Reed (formerly Park)

Acme Co. + Acme + 3 → Legal: Acme Co. ¶ DBA: Acme

Reed, Ava → Ava Reed

Ava Reed → Ava

Ava Reed → Reed

Ava Reed → Reed, Ava

Reed, Ava → Ava

Reed, Ava → Reed

Ava Marie Reed → Marie

Ava Marie Reed → Ava Reed

Reed, Ava Marie → Ava

Reed, Ava Marie Anne → Marie Anne

Reed-Park → Reed

Reed-Park → Park

Ava (Avie) Reed → Avie

Ava (Avie) Reed → Ava Reed

Ava Reed, Jr. → Jr.

Ava Reed, Jr. → Ava Reed

Ava Reed <ava@example.com> → Ava Reed

Ava Reed & Noah Park → Ava Reed

Ava Reed & Noah Park → Noah Park

Mary Ann de la Cruz + Mary Ann → de la Cruz

Mary Ann de la Cruz + de la Cruz → Mary Ann

Ava Reed ¶ 12 Oak St → Ava Reed

Attn: Ava Reed → Ava Reed

"Ava Reed" <ava@example.com> → Ava Reed

Ava Reed — Treasurer → Ava Reed

Ava Reed (0027) → Ava Reed

01. Ava Reed → Ava Reed

Reed Ava → Ava Reed

Ava and Noah Reed → Noah

Ava|Reed + separator | → Ava

Ava Reed;Noah Park;Mia Chen + 2 → Noah Park

Ava Reed, Jr. → Ava Reed Jr.

Ava Reed ¶ Noah Park → Noah Park

Ava de la Cruz + de la → de la Cruz

Ava Reed Park → Reed Park

Mary Ann Reed → Mary Ann

Nia van Dijk + van Dijk → van Dijk, Nia

Ava Marie Reed → M.

Ava Marie Reed → AR


Ava Reed; Noah Park → Ava Reed ¶ Noah Park

Ava Reed ¶ Noah Park → Ava Reed; Noah Park

0042|Ava Reed|Active → Ava Reed

First=Ava;Last=Reed → Ava Reed

Active|Ava Reed + | → Ava Reed

0042Ava Reed + 4 characters → Ava Reed

Ava Reed0042 + 4 characters → Ava Reed

Ava-Reed-0042 + separator - → Ava-Reed

NE|Active|Ava Reed + | → Ava Reed

de la Cruz|Mary Ann + | → Mary Ann de la Cruz

Reed, Ava Marie, Jr. → Ava Marie Reed Jr.

Ava Reed, Jr. + Reed → Reed, Ava, Jr.

Ava Reed, CPA, MBA → Ava Reed

Ava Reed aka Avie Reed → Avie Reed

AMR → A.M.R.

AvaReed + Ava → Ava Reed

Reed|Ava|Marie + | → Ava Marie Reed

Ava Marie Reed + position 2 → Marie

" Ava Reed " → Ava Reed

Turns formula results into plain names

Removes the hidden spaces TRIM misses

AVA REED → Ava Reed

ava reed → AVA REED

AVA REED → ava reed

Ava Reed Jr. + Jr. → Ava Reed

Dr. Ava Reed + Dr. → Ava Reed

A. M. Reed → A M Reed

O’Neill → O'Neill

Reed‑Park → Reed-Park

Reed - Park → Reed-Park

O' Neill → O'Neill

Ava»Reed → Ava Reed

Ava ¶ Reed → Ava Reed

Ava Reed¶ → Ava Reed

Re·ed → Reed

"Ava Reed" → Ava Reed

Reed ,Ava → Reed, Ava

N/A + N/A → blank

O’ Neill → O’Neill

van dijk + van Dijk → van Dijk

Ava [narrow no-break space] Reed → Ava Reed

[BOM]Ava Reed → Ava Reed

Ava Reed → Ava Reed

O'Neill → O'Neill

Ava Reed, → Ava Reed

• Ava Reed → Ava Reed

blank + Ava Reed + A. Reed → Ava Reed

Ava Reed* → Ava Reed


Ava Reed¹ → Ava Reed

Ava [VIP] Reed + [VIP] → Ava Reed

Ava_Marie_Reed → Ava Marie Reed

Ava\nReed → Ava Reed

Re[soft hyphen]ed → Reed

Numeric cell 123 → Review value type

Use correction + Ava Reed + Ava Park → Ava Park

[Ava Reed] → Ava Reed

Ava ""Avie"" Reed → Ava "Avie" Reed

Ava Reed & Noah Park → Ava Reed & Noah Park

Ava<br>Reed → Ava Reed

Ava \"Avie\" Reed → Ava "Avie" Reed

Ava [line separator] Reed → Ava Reed

Ava [thin space] Reed → Ava Reed

Ava Reed Ava Reed + expected Ava Reed → Ava Reed

Ava Reed Reed + surname Reed → Ava Reed

o’Neill → O’Neill

2026 + 11 + 4 → November 4, 2026

2026-11-04 → November 4, 2026

11/04/2026 → November 4, 2026

04/11/2026 → November 4, 2026

20261104 → November 4, 2026

November 4 at 2:30 PM → November 4 only

14 + 30 + 15 → 2:30:15 PM

14:30:15 as text → 2:30:15 PM

November 4, 2026 2:30:15 PM → 2:30:15 PM

2:30:15 PM → 14

2:30:15 PM → 30

2:30:15 PM → 15

11/4/2026 + 2:30:15 PM → 11/4/2026 2:30:15 PM

2:30:15 PM → 2

2 + 30 + p.m. → 2:30 PM

11/4/2026 2:30:15 PM + 9:05:00 AM → 11/5/2026 9:05:00 AM

4-Nov-2026 + 2:30:15 PM → November 4, 2026 2:30:15 PM

0905 → 9:05 AM

143015 → 2:30:15 PM

November 4, 2026 → 2026-11-04

November 4, 2026 → November

November 4, 2026 → 2026

November 4, 2026 → 11

November 4, 2026 → 4

November 4, 2026 → Wednesday

Monday → 1; Sunday → 7

March 9, 2026 → quarter 1

January 1, 2021 → ISO week 53

November 4, 2026 → 2026-11

November 4 → November 1

February 12, 2024 → February 29

December 15, 2026 → January 1, 2027

March 10, 2024 → February 29

November 4, 2026 → January 1, 2026

November 4, 2026 → December 31, 2026

November 4, 2026 → October 1, 2026

March 9, 2026 → March 31, 2026

February 29, 2024 → 29

Wednesday November 4, 2026 → Monday November 2, 2026

Wednesday November 4, 2026 → Sunday November 8, 2026

December 31, 2026 + 1 day → January 1, 2027

November 4, 2026 + 2 weeks → November 18, 2026

May 31, 2026 + 1 month → June 30, 2026

January 15, 2026 + 1 month → February 28, 2026

Monday March 9, 2026 → Monday March 16, 2026

November 4, 2026 to November 5, 2026 → 1 day

November 4, 2026 to November 5, 2026 → 2 dates

November 4, 2026 → 26 days left in November

November 4, 2026 → 57 days left

Friday January 1, 2027 + 1 weekday → Monday January 4, 2027

November 4, 2026 to November 10, 2026 → 5 weekdays

November 4, 2026 to November 10, 2026 → 5 workdays

Thursday January 15, 2026 + 1 workday → Sunday January 18, 2026

November 4, 2026 → Monday, November 2, 2026

January 15, 2026 → Friday, January 30, 2026

November 4, 2026 → November 4, 2026 as text, 0 → blank

November 4, 2026 → 4 November 2026, 0 → blank

November 4, 2026 → Nov 4, 2026

November 4, 2026 → Wednesday, November 4, 2026; 0 → blank

November 4, 2026 → 11/04/2026

November 4, 2026 → 20261104

November 4, 2026 → November 2026

Ava Reed + November 4, 2026 → Ava Reed (DOB: 11/04/2026)

December 31, 2026 to December 31, 2026 → December 31, 2026

2026 + 11 → November 1, 2026

2026-11 → November 1, 2026

Text 46330 → November 4, 2026

4-Nov-2026 → November 4, 2026

Nov 4, 2026 → November 4, 2026; real dates stay

2026-11-04T14:30:15Z → November 4, 2026

DOB: 4-Nov-2026 → November 4, 2026

Nov[NBSP]4,[NBSP]2026 → November 4, 2026

11/04/26 + 2000 → November 4, 2026

110426 + 2000 → November 4, 2026

2026365 → December 31, 2026

April 11, 2026 → November 4, 2026

11042026 → November 4, 2026

1904 date number 44868 → November 4, 2026

'4-Nov-2026 → November 4, 2026

#4-Nov-2026# → November 4, 2026

[blank] or January 1, 2027 → January 1, 2027

November 4, 2026 to November 4, 2036 → 10 years

November 4, 2026 to November 4, 2027 → 12 months

November 4, 2026 to June 4, 2029 → 7 months

November 4, 2026 – June 4, 2029 → 2 year(s), 7 month(s)

November 4, 2026 and March 4, 2027 → November 4, 2027

November 4, 2001 into January 15, 2026 → November 4, 2026

November 4, 2001 and January 15, 2026 → November 4, 2025

February 29, 2024 + 1 year → February 28, 2025

November 4, 2026 in a July-start year → 2026

November 4, 2026 in a July-start year → 2027

November 4, 2026 in a July-start year → quarter 2

November 4, 2026 in a July-start year → fiscal month 5

04-NOV-26 02.30.15.123456 PM + 20 → November 4, 2026

04-NOV-2026 14.30.15.123456 → November 4, 2026

Unix seconds 1793802615 → November 4, 2026

Unix milliseconds 1793802615000 → November 4, 2026

/Date(1793802615000)/ → November 4, 2026

126308 → November 4, 2026

N/A → blank; 4-Nov-2026 → November 4, 2026

Wed, 04-Nov-2026 14:30:15 +0000 → November 4, 2026

2026 + 10 + 4 → November 4, 2026

Date number 46330 → 1904 date number 44868

20261104143015 → November 4, 2026

4-Nov-2026 → 11/04/2026; next week → Review date

Birth year 2001 → 2001 as text

November 4, 2026 → 4th November 2026

November 4, 2026 → day 308

November 4, 2026 to November 11, 2026 → 1 week

November 4, 2026 to December 1, 2026 → 1 month boundary

December 31, 2026 to January 1, 2027 → 1 year boundary

February 29, 2024 → 366 days

2026 + month 2 + day 31 → February 28, 2026

November 4, 2026 to November 10, 2026 → 2 weekend dates

7/4/2026 11:59:59 PM to 7/5/2026 12:01:59 AM → 1

January 1, 2027 → ISO week-year 2026

January 1, 2027 → 2026-W53

November 4, 2026 → 2026-Q4

2026 + quarter 4 → October 1, 2026

2026 + quarter 4 → December 31, 2026

November 4, 2026 with a July start → July 1, 2026

November 4, 2026 in a July-start year → June 30, 2027

November 4, 2026 with a July start → October 1, 2026

November 4, 2026 with a July start → December 31, 2026

2026 + week 45 + weekday 3 → November 4, 2026

November 4, 2026 → number 202611

Saturday July 4, 2026 → Monday July 6, 2026

Sunday May 31, 2026 → Friday May 29, 2026

November 4, 2026 + weekday 1 → Monday November 2, 2026

November 4, 2026 + weekday 5 → Friday November 27, 2026

Monday August 17, 2026 + weekday 1 → Monday August 17, 2026

November 4, 2026 to November 5, 2026 → November 4, 2026

December 31, 2026 + earliest January 4, 2027 → January 4, 2027

November 4, 2001 → 11/04

Ava Reed → November 5, 2026

11/4/2026 to 11/30/2026 → November 4 through November 30, 2026

November 4–10, 2026 and November 10–20, 2026 → 1 shared date

November 4, 2026 to November 6, 2026 → 1 uncovered date

2026-11-4 → November 4, 2026

11/4/2026 → November 4, 2026

4/11/2026 → November 4, 2026

<dob>2026-11-04</dob> → November 4, 2026

4-Nov-2026 (verified) → November 4, 2026

11/4 + 2026 → November 4, 2026

4/11 + 2026 → November 4, 2026

2024-02 → February 29, 2024

2026-Q4 → October 1, 2026

FY2026 with July start → July 1, 2025

FY2026 with July start → July 1, 2026

112026 → November 1, 2026

04112026 → November 4, 2026

261104 + 2000 → November 4, 2026

041126 + 2000 → November 4, 2026

2026-W45-3 → November 4, 2026

November 4, 2026 2:30:15 PM + 10 hours → November 5, 2026

0224 + 2000 → February 29, 2024

November-2026 → November 1, 2026

11/2026 → November 1, 2026

2611 + 2000 → November 1, 2026

November 4, 2026 → Unix seconds 1793750400

November 4, 2026 → Unix milliseconds 1793750400000

November 4, 2026 → text 126308

November 4, 2026 → 2026308

November 4, 2026 → 110426

November 4, 2026 → 041126

November 4, 2026 → 261104

November 4, 2026 → 11042026

November 4, 2026 → 04112026

110426 + 2000 → 2026-11-04

2026 + 11 + 4 → 2026-11-04

November 4, 2026 → nov-2026

2026 + 11 → November 2026

2026 + 11 + 4 → text "November 4, 2026" for a letter

2001-11-04 → November 4, 2001; 2001-11 → Review

1998 stays 1998; 2001-11 → November 2001

14:30 → 2:30 PM, 00:00 → 12:00 AM, blank stays blank

2:30:15 PM → 14:30:15

2:30 PM → 14:30

Duration 49:30 → text 49:30, not 1:30

49:30:15 → text 49:30:15, not 1:30:15

A negative 90-minute difference → -1:30

49.5 hours → 49:30

49:30 → 49.5 hours

2970 minutes → 49:30

49:30 → 2970 minutes

178215 seconds → 49:30:15

49:30:15 → 178215 seconds

49 hours and 30 minutes → 49:30

11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM → 49.5 hours

11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM → 2970 minutes

11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM → 178200 seconds

11:30 PM to 7:15 AM → 7:45

49:30 → 49 whole hours

2:30–5:30 PM and 4:30–7:30 PM → 1:00 shared

2:30:15 PM to 4:00:15 PM → 1:30:00; reversed → Review order

11:30 PM plus 90 minutes → 1:00 AM

12/31/2026 11:30:00 PM + 90 minutes → 1/1/2027 1:00:00 AM

11/4/2026 2:30:15 PM + 10 hours → 11/5/2026 12:30:15 AM

12/31/2026 11:30:00 PM + 1800 seconds → 1/1/2027 12:00:00 AM

7/4/2026 11:59:59.6 PM → 7/5/2026 12:00:00 AM

7/4/2026 11:59:59 PM → 7/5/2026 12:00:00 AM

1/1/2027 7:15:30 AM, 10 minutes → 1/1/2027 7:20:00 AM

7/4/2026 11:59:59 PM up to 15 minutes → 7/5/2026 12:00:00 AM

1/1/2027 7:15:30 AM, 10 minutes → 1/1/2027 7:10:00 AM

2026-11-04T14:30:15 → November 4, 2026 2:30:15 PM

2026-11-04T14:30:15.123 → 11/4/2026 2:30:15.123 PM

T14:30:15 → 2:30:15 PM

26-11-04 14:30:15 + 2000 → November 4, 2026 2:30:15 PM

11/04/26 2:30:15 PM + 2000 → November 4, 2026 2:30:15 PM

04-NOV-2026 14.30.15 → November 4, 2026 2:30:15 PM

04-NOV-2026 02.30.15.123456789 PM → 11/4/2026 2:30:15.123 PM

04-NOV-2026 14.30.15.123456 → 11/4/2026 2:30:15.123 PM

Wed Nov 04 14:30:15 2026 → November 4, 2026 2:30:15 PM

20261104143015 → November 4, 2026 2:30:15 PM

20261104 143015 → November 4, 2026 2:30:15 PM

4-Nov-2026 | 14:30:15 → November 4, 2026 2:30:15 PM

Unix seconds 1793802615 → November 4, 2026 2:30:15 PM

Unix milliseconds 1793802615000 → November 4, 2026 2:30:15 PM

/Date(1793802615000)/ → November 4, 2026 2:30:15 PM

Seconds since 1960 2109421815 → November 4, 2026 2:30:15 PM

04-NOV-26 02.30.15.123456 PM + 20 → 11/4/2026 14:30:15.123

NULL → blank; 2026-11-04T14:30:15 → November 4, 2026 2:30:15 PM

2026-11-04T14:30:15+05:30 → November 4, 2026 9:00:15 AM

2026-11-04T14:30:15.123-10:00 → 11/5/2026 12:30:15.123 AM

11/4/2026 2:30:15 PM, offset 5.5 → 11/4/2026 9:00:15 AM UTC

11/4/2026 2:30:15 PM, 5.5 to -6 → 11/4/2026 3:00:15 AM

-03:30 → -210 minutes

14:30:15+05:30 → 09:00:15 UTC clock

2026-11-04 14:30:15 UTC, label UTC → November 4, 2026 2:30:15 PM

November 4, 2026 2:30:15 PM → 2026-11-04T14:30:15

November 4, 2026 2:30:15 PM → 2026-11-04T14:30:15Z

11/4/2026 2:30:15.123 PM → 2026-11-04T14:30:15.123

11/4/2026 2:30:15 PM, -05:00 → 2026-11-04T14:30:15-05:00

11/4/2026 14:30:15.123, -05:00 → 2026-11-04T14:30:15.123-05:00

2:30:15 PM → T14:30:15

November 4, 2026 2:30:15 PM → Unix seconds 1793802615

November 4, 2026 2:30:15 PM → Unix milliseconds 1793802615000

11/4/2026 2:30 PM → November 4, 2026 at 2:30 PM

11/4/2026 2:30 PM → Nov 4, 2026 2:30 PM UTC

November 4, 2026 2:30:15 PM → 20261104_143015

2:30:15[nonbreaking space]PM → 2:30:15 PM

14.30.15 → 2:30:15 PM

2:30:15(PM) → 2:30:15 PM

14h30m → 2:30 PM

49:30 as text → 49:30, not 1:30

49:30:15 as text → 49:30:15, not 1:30:15

2970:15 (minutes:seconds) as text → 49:30:15

PT49H30M15S → 49:30:15

2 01:30:15 → a 49:30:15 duration

49h 30m → an elapsed duration over two days

49,5 hours → 49:30 elapsed

11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM, 0:30 break → 49:00

36:10 in 15-minute blocks → 145 blocks

49:30 in 60-minute blocks → 30 minutes left

49:30 → 2d 1h 30m

49:30:15 → 2970m 15s

49:30:15 → PT49H30M15S

49:30:15 → 2970:15

49.30 (hours.minutes) → 49:30

-0:30 → a negative 30-minute numeric duration

Noon → 12:00 PM; midnight → 12:00 AM

November 4, 2026 + 24:00 → November 5, 2026 12:00 AM

Boston + MA + 02108 → BOSTON MA 02108

12 OAK ST + APT 5 → 12 OAK ST APT 5

Street, city, state, ZIP → 12 OAK ST, BOSTON, MA 02108

123 → PO BOX 123

Route 2 plus box 145 → RR 2 BOX 145

APO + AE + 09021 → APO AE 09021

Ottawa + ON + K1A 0B1 → OTTAWA ON K1A 0B1

Northeast in its own direction field → NE

12 Oak St + 12 Oak St → line 2 blank

12 Oak St [Windows break] Boston → 12 Oak St ¶ Boston

12 Oak St\nBoston, MA 02108 → two address lines

12 Oak St<br>Boston, MA 02108 → two address lines

2108 → text 02108

21081234 → 02108-1234

02108 + 1234 → 02108-1234

02108-1234 → text 02108

02108-1234 → 1234; ZIP alone → blank

021081234 → 02108-1234

2108 → 02108; 01002-4410 stays as it is

02108 → text 021

21081234 → text 02108

US-02108 → 02108; CA-K1A 0B1 → Review country prefix

2108 → 02108; 106103 → Review ZIP

02108 + 02108-1234 → 02108-1234

sw1a1aa → SW1A 1AA

k1a0b1 → K1A 0B1

021081234 + US → 02108-1234; k1a0b1 + CA → K1A 0B1

143015 → 2:30:15 PM and 2330 → 11:30:00 PM

14:30, pattern hh:mm → 2:30:00 PM

2026-11-04T14:30:15 → November 4, 2026 2:30:15 PM, or Review timestamp

2026-11-04T14:30:15.123 → 11/4/2026 2:30:15.123 PM, but .12 → Review timestamp

Text 9:05 AM → 9:05:00 AM; timestamps keep their time

2026-11-04T14:30:15 → November 4, 2026 2:30:15 PM; real timestamps stay

2:30:15 PM with hh:mm:ss → 14:30:15

12:00:00 AM, pattern hhmmss → 000000, not 0

0001-01-01T00:00:00 → blank; 2026-11-04T14:30:15 → 11/4/2026 14:30:15

2:30:15 PM, +05:30 → T14:30:15+05:30

11/4/2026 2:30:15 PM, -00 and 30 → 11/4/2026 2:00:15 PM

11/4/2026 + 2:30:15 PM, offset -10 → 11/5/2026 12:30:15 AM UTC

11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM → 49:30:00

11/4/2026 14:30 to 11/6/2026 16:00, at 11/5/2026 15:15 → 50%

P2DT1H30M15S → 49:30:15

-2.01:30:15 → -2.062674 days

134382762150000000 → November 4, 2026 2:30:15 PM

639293994150000000 → November 4, 2026 2:30:15 PM

Unit 5 + civic number 12 → 5-12 OAK ST

Box 4001 plus STN A → PO BOX 4001 STN A

London + SW1A 1AA → LONDON ¶ SW1A 1AA

01067 + DRESDEN → 01067 DRESDEN

US + 02108 → US|02108; CA + m5v 2t6 → CA|M5V2T6

Milliseconds since 1960 2109421815000 → November 4, 2026 2:30:15 PM

Seconds since 1582 14013181815 → November 4, 2026 2:30:15 PM

4002791415, era 0, 2147483648 → 11/4/2026 14:30:15.500

Unix microseconds 1793802615123456 → 11/4/2026 2:30:15.123 PM

493015 → 49:30:15, not 1:30:15

-2.01:30:15.5000000 → -2.062679 days

Wed, 04-Nov-2026 14:30:15 GMT → November 4, 2026 2:30:15 PM

20261104143015+0530 → November 4, 2026 9:00:15 AM

11/4/2026 2:30:15 PM, UTC → 2026-11-04T14:30:15Z

2 + 30 + 15 + PM → 2:30:15 PM

Same-day start and end → Nov 4, 2026 2:30 PM–3:15 PM

11/4/2026 2:30:15 PM + 2:30:15 PM → 11/5/2026 2:30:15 PM

20261104143015.123456+330 → 11/4/2026 9:00:15.123 AM

00000002013015.123456:000 → 49:30:15, not a date

20261104143015.0Z → November 4, 2026 2:30:15 PM

261104143015Z → November 4, 2026 2:30:15 PM

Unix microseconds -1361957384876544 → 11/4/1926 2:30:15.123 PM

1793802615 s, 500000000 ns → 11/4/2026 14:30:15.500

178215 s, 500000000 ns → 2.062679 days

20261104 + 143015 → November 4, 2026 2:30:15 PM

-00 00:30:00.000000 → -0.020833 days

+02-03 → 27 months

{ts '2026-11-04 14:30:15'} → November 4, 2026 2:30:15 PM

/Date(1793802615000+0100)/ → November 4, 2026 2:30:15 PM

Wed Nov 04 2026 14:30:15 GMT-0500 (EST) → 11/4/2026 19:30:15

Wed, 04-Nov-2026 14:30:15 +0530 → November 4, 2026 9:00:15 AM

90 Minutes → 0.062500 days

2:30:15 PM to 5:10:00 PM in 15-minute blocks → 9

-, 49, 30 and 15 → -2.062674 days

021081234 + 5 + - → 02108-1234

1002 + 0 → 01002-0000

Ava Reed or ATTN Ava Reed → ATTN Ava Reed

ATTN Ava Reed ¶ 12 Oak St → Ava Reed

Acme Co. | MAILSTOP: 4B-210 → 4B-210

Acme Co. | MAILSTOP: 4B-210 → Acme Co.

A + 02 + 004B → BLDG A FL 02 RM 004B

APT + APT 5 → 5

12 Oak St #5 + APT → 12 Oak St APT 5

12 Oak St #5 → 12 Oak St # 5

12 Oak St APT 5 + APT → 5

12 Oak St APT 5 + APT → 12 Oak St

STE 200 + 45 → 12 Oak St STE 200 PMB 45

Postal box + 123 → PO BOX 123

#8 PMB 112 → Facility secondary: #8; customer PMB: 112

Boston MA 02108-1234 + 15 → Boston MA ¶ 02108-1234

Acme Office Supply Company + 20 → Acme Office Supply ¶ Company

6-line label, 3 address + 1 program → 2 lines left

Centerline Medical Center + Center, Ctr → Centerline Medical Ctr

12 Oak St ¶ NULL ¶ Boston → 12 Oak St ¶ Boston

12 Oak ¶ St ¶ Boston + break 1 → 12 Oak St ¶ Boston

12 Oak St ¶ ¶ Boston, MA 02108 + 3 → Boston, MA 02108

12 COURT STREET + STREET, ST → 12 COURT ST

108‑02 → 108-02

12 1/2 Oak St → 12 1/2

12 1/2 Oak St → Oak St

820 W 400 N → 400

N + 89 + W + 16786 → N89W16786

12, A, Letter → 12A

PRINCIPALE + RUE + French → RUE PRINCIPALE

STAR ROUTE + 007 + 001-02 → HC 7 BOX 001-02

HC 1 BOX 120 → 02108-4410 (box range, not route)

AAN1 + 2 → N1

12 Oak St&Oak St&12 → 12 Oak St

1234567890 as a number → 1234567890 as text

12345678 → 012345678

012345678 → 01-2345678

01-2345678 → 012345678

01 - 2345678 → 012345678

012345678 → XXXXX5678

012345678 → **-***5678

1234567890 → NPI ending 7890

1234567890 + 012345678 → NPI: 1234567890 | TIN: 012345678

NPI + 1234567890 → 1234567890 (approved type)

1234567890 + 000123 → NPI: 1234567890

EIN + 023456789 → 02-3456789

12345678 → 01-2345678

NPI: 1234567890 → 1234567890

AB + 123 → AB000123

AB000001 → AB000002

AB000123 → 123

https://example.test/provider/000123?view=full → 000123

example.test/p?providerId=000123&view=full + providerId → 000123

{"providerId":"000123"} → 000123

1234567890123456 → 1234 5678 9012 3456

A7 with width 4 → [A7 ] (4 characters)

012345678.0 → 012345678

1.23456789E+09 → 1234567890

'000123 → 000123

123 as a number → 123 as text

NULL → blank; 000000001 → 000000001 (zeros kept)

A7 + width 4 → 00A7

P01234 + S007 → P01234|S007

R.N. → Registered Nurse

BSN, RN, LPN minus LPN → BSN, RN

BSN, RN → 2 credentials

Ava Reed, BSN, RN → BSN, RN

Registered Nurse (RN) → RN

BSN, RN → BSN

RN + Verified → RN

RN + NY + 00012345 → RN (NY 00012345)

RN + Lakeview Board → RN – Lakeview Board

RN + Retired → RN (retired)

mailto:ava@example.com?subject=Hello → ava@example.com

Ava Reed <ava@example.com> → ava@example.com

ava @ example.com → ava@example.com

Ava.Reed@EXAMPLE.COM → Ava.Reed@example.com

ava@example.com; → ava@example.com

ava@old.test → ava@new.test

ava@example.com → ava@example.com

ava%2Bteam%40example.com → ava+team@example.com

Ava.Reed+team@example.org → Ava.Reed+team

ava@EXAMPLE.COM → example.com

ava@dept.example.org → org

ava@example.com or ava@example.org → ava@example.com

ava + example.com → ava@example.com

Ava Reed + ava@example.com → Ava Reed <ava@example.com>

ava@example.com + Ava Reed → Email Ava Reed (a link)

ava@example.com → a***@example.com

-$1,234.50 minus the $ label → -1234.5

1.234,56 € → 1234.56

1 234,56 EUR → 1234.56

($1,234.50) → -1234.5

90.02- → -90.02

1.2K → 1200

A dash - → 0, a blank stays blank

−1,234.50 with a math minus → -1234.5

12345 with scale 2 → 123.45

1,234.56 as text → 1234.56; numbers stay as they are

-12 units and -34 cents → -$12.34

USD 1,234.56 (USD required) → 1234.56

123.45 → 12345 cents

123.45 → +000012345

-123.45 → 123.45-

1234.5 → text 1234.50

1234.5 → 1234,50

1234.5, USD, 2 decimals → USD 1,234.50

1234.5 → $1,234.50

-1234.5 → ($1,234.50)

1234.56 → $1,235

0.004 → Zero balance

-123.45 → Credit $123.45

100 and 250 → $100.00–$250.00

1500 → $1.5k

123.456 to 2 decimals → 123.46

1.999 → $1.99

1.001 → 1.01; -1.001 → -1.01

12.33 → 12.35

1.21 → 1.25

1.24 → 1.20

0.004 within 0.01 → 0

0.5 → 4/8

6/8 → 3/4

7/4 → 1 3/4

12 and 0.5 → 12 1/2

15 and 20 → 15 out of 20

1/2 as text → 0.5

-1 1/2 as text → -1.5

1 and 1/2 → 1.5

3 and 4 → 0.75; 3 and 0 → Review zero denominator

-1.5 → -0.5

0.26 to the nearest 1/4 → 0.25

1/2 + 1/4 → 0.75

3/4 - 1/2 → 0.25

1/2 times 3/4 → 0.375

1/2 divided by 1/4 → 2

0.5 FTE of 40 hours → 20 hours

0.125, 1 decimal → 12.5%

1 and 4 → 25.0%; 2 and 0 → Review zero total

0.05 → +5.0 percentage points

0.125 → +12.5%

12.5 as points → 12.5% as text

12.5% as text → 12.50% as a number

12,5% as text → 0.125

12.5 as points → 12.5% as a rate

12.5% as a rate → 12.5 as points

12.5 as text → 0.125

125 basis points → 1.25% as a rate

1.250% → 125 basis points

-1 meaning missing → blank, not -1.0%

100 to 120 → 20%

10% to 15% → 5.00 percentage points

100 with a 10.0% increase → 110

100 with a 20.0% decrease → 80

110 after a 0.1 (10%) increase → 100

90 after a 10% decrease → 100

10% then 10% increase → 21%

(201) 555-0123 → 2015550123

12015550123 → 2015550123

tel:+12015550123;ext=12 → +12015550123

tel:+12015550123;ext=0012 → 0012

0012015550123 → +12015550123

2079460123, width 11 → 02079460123

2015550123 → (201) 555-0123

2015550123 → +12015550123

(201) 555-0123 and 0012 → (201) 555-0123 ext. 0012

1 + 2015550123 → +12015550123

2015550123 → ******0123

2015550123 + 2015550142 → Phone: 2015550123¶Fax: 2015550142

+12015550123 and 0012 → tel:+12015550123;ext=0012

201-555-0123 Verified + backup → 201-555-0123

Mobile, 201-555-0123, 617-555-0142 → 201-555-0123

201-555-0123 + Do not use → blank

Reed\F\Ava → Reed|Ava

First_x0020_Name → First Name

Email; Phone; Text message; → Email, Phone, Text message

12.345 × 3 → 37.04

125.5 × 0.9215 to 2 decimals → 115.65

640.25 with limits 25 to 500 → 500

90.00 for 10 of 30 units → 30.00

-12.345 to 2 decimals → -12.35

en-US → en

00000123M → -12.34

125.50 CR → -125.5

1,234.50 → 1234.5; 1,23.00 → Review amount pattern

12345 cents → 123.45

12.34 with width 10 → *****12.34

120.00 + 15.50 + 9.75 → 145.25

-0.004 → $0.00

12.34560% at 2 percent decimals → 12.3500%

12.3456% to 2 decimals → 12.34%

12.3456% to 2 decimals → 12.35%

1:4 ratio → 20% share, not 25%

1 in 20 → 5.0%

12.5 percent → 0.125

12.5 Percent points → 12.50% as a rate

2x multiplier → 100% change

12.5% → About 1 in 8

45 done of a 40 goal → 100%

0.26 up to the next 1/4 → 0.5

0.45 down to the previous 1/4 → 0.25

-7/4 → -1 3/4

1/2 in eighths → 4/8

1⁄2 with a fraction slash → 0.5

3/4 → 0.75; 3/0 → Review: check the fraction

MCD + ISS01 + MA + 004512 → MCD|ISS01|MA|004512

123456789 + SSN → 123-45-6789

+39065550123, code 39 → 065550123

5550123 + 201 → 2015550123

02079460123 + 0 → 2079460123

0012015550123 + 00 → +12015550123

7042 + example.com → tel:7042;phone-context=example.com

Ava "Avie" Reed → Ava "Avie" Reed

Ava Reed & Noah Park → Ava Reed & Noah Park

Jos\u00e9 Williams → José Williams

Ava+Reed+%2B+Noah+Park → Ava Reed + Noah Park

"Ava ""Avie"" Reed" → Ava "Avie" Reed

<![CDATA[Ava & Noah Reed]]> → Ava & Noah Reed

en_US.UTF-8 → en-US

2AC4DE5FG67 → 2AC4-DE5-FG67

XKM441720 + 1, width 2 → XKM44172001

11/4/2026 + 12/4/2026 → From 11/04/2026 through 12/04/2026

PT-004512, SB-117340, PH-208815 + Subscriber → SB-117340

Quantity, %, 20 → 20.00%

Labs + In + Family + Annual → Labs (In; Family; Annual)

20 allowed, 6 used → 14 left

500.00 USD allowed, 125.50 USD used → 374.50 left

Money, 1500, USD → USD 1500.00

11/4/2026 to 12/4/2026 → 11/04/2026 through 12/04/2026

5 + 2 → PGY-5; program year 2

11/4/2026 + 12/4/2026 + TRUE → December 4, 2026

IN 11/4/2026 2:30:15 PM, OUT 10:45:15 PM → 8.25 hours

8.5 hours, 0.5 meal, deduction requested → 8 hours

8 hours, Delta -0.5 → 7.5 hours

38.5 + 0.75, not yet included → 39.25 hours

Apply: work 11/4/2026, apply 11/12/2026 → 11/12/2026

1.5 workdays at 8 paid hours → 12 hours

0.5 elapsed days → 12 hours

8.5 hours, 0.25 meal, 30-minute minimum → 8 hours

8.5 hours, nursing, offsite → 0 hours

7 hours 33 minutes, six-minute bands → 7.6 hours

124.5, 3 rejected → 124.50 accepted hour(s); review 3 rejected row(s)

phone + 201-555-0123 → phone: 201-555-0123

Nurse, no actor → Unassigned participant role: Nurse

booked + tentative → booked; patient response=tentative

booked + declined → Review: booked but participant declined

finished + arrived → finished current; history excerpt=arrived

reserved, Bed 4A → Reserved location: Bed 4A

P451 + V208 → Pre-admission ID: P451; encounter ID: V208

ENT + Lockbox → Account owner: ENT; payment recipient: Lockbox

48.60 → Source maximum you may be billed: 48.60

C101 + 1 + 2 + 1 → C101 | item=1 | detail=2 | subdetail=1

-25.00 + Recovery → Payment-level adjustment: -25.00; Recovery

Complete + Partial → Complete processing; payment=Partial

11/4/2026, Estimated issue → Estimated issue 11/04/2026

CI-101 → Resolve ChargeItem reference: CI-101

120.00 net, 129.60 gross, Net → 120.00

discount 25.00 → -25.00

Reference + Lab panel → Lab panel

MSH|^~\&|LAB|SITEA → |

A40 + MR4012 + MR3807 → Surviving=MR4012; prior=MR3807

1001 LAB, 1001 RIS → Placer: 1001 [LAB]; filler: 1001 [RIS]

replaces, SR-101 → Replacement of prior request: SR-101

Ava Reed + ENT → Requester: Ava Reed; requested performer: ENT

20 → 20 half-day visits per 1 month

completed + failed → completed request; communication task=failed

Ava Reed → Assigned owner: Ava Reed

on-hold + Awaiting auth → on-hold; business state=Awaiting auth